CREATE OR REPLACE PACKAGE DISCOUNT_USER.CJ_PRODUCT_SEARCH_PKG AS

    
    
    PROCEDURE insertcj(
    p_adid IN DISCOUNTS_CJ.AD_ID%TYPE,
    p_advertiserid IN DISCOUNTS_CJ.ADVERTISER_ID%TYPE,
    p_advertisername IN DISCOUNTS_CJ.ADVERTISER_NAME%TYPE,
    p_advertisercategory IN DISCOUNTS_CJ.ADVERTISER_CATEGORY%TYPE,
    p_buyurl IN DISCOUNTS_CJ.BUY_URL%TYPE,
    p_catalogid IN DISCOUNTS_CJ.CATALOG_ID%TYPE,
    p_currency IN DISCOUNTS_CJ.CURRENCY%TYPE,
    p_description IN DISCOUNTS_CJ.DESCRIPTION%TYPE,
    p_imageurl IN DISCOUNTS_CJ.IMAGE_URL%TYPE,
    p_instock IN DISCOUNTS_CJ.IN_STOCK%TYPE,
    p_isbn IN DISCOUNTS_CJ.ISBN%TYPE,
    p_manufacturername IN DISCOUNTS_CJ.MANUFACTURER_NAME%TYPE,
    p_manufacturersku IN DISCOUNTS_CJ.MANUFACTURER_SKU%TYPE,
    p_name IN DISCOUNTS_CJ.NAME%TYPE,
    p_price IN DISCOUNTS_CJ.PRICE%TYPE,
    p_retailprice IN DISCOUNTS_CJ.RETAIL_PRICE%TYPE,
    p_saleprice IN DISCOUNTS_CJ.SALE_PRICE%TYPE,
    p_sku IN DISCOUNTS_CJ.SKU%TYPE,
    p_upc IN DISCOUNTS_CJ.UPC%TYPE);
    
   
    
   
 
END CJ_PRODUCT_SEARCH_PKG;
/